-- Fig 13.20(a)

create table Customers2 of XMLtype;


-- Fig 13.29(b)
insert into customers2 values(
'<CUSTOMER TYPE="Corporate" STATUS="Active"> 
	<NAME>WorldWide Travel Agency</NAME>
	<ADDRESS>
	<STREET>10 Main Street</STREET> 
	<CITY>New York</CITY>
	<STATE>NY</STATE>
	<ZIP>10001</ZIP>
	</ADDRESS>
	<TELEPHONE>	
	<AREACODE>212</AREACODE>
	<PHONE>123 4567</PHONE>
	</TELEPHONE>
</CUSTOMER>');

insert into customers2 values(
'<CUSTOMER TYPE="Individual">  <!--start of individual customers -->
	<NAME>Mary Jones</NAME>
	<ADDRESS>
	<STREET>25 Spruce Street</STREET> 
	<CITY>San Diego</CITY>
	<STATE>CA</STATE>
	<ZIP>92101</ZIP>
	</ADDRESS>
	<TELEPHONE>
	<AREACODE>619</AREACODE>
	<PHONE>555 6789</PHONE>
	</TELEPHONE>
</CUSTOMER>');

insert into customers2 values(
'<CUSTOMER TYPE="Individual" STATUS="Inactive">
	<NAME>Alice Adams</NAME>
	<ADDRESS>
	<STREET>25 Orange Blossom Street</STREET> 
	<CITY>Miami</CITY>
	<STATE>FL</STATE>
	<ZIP>60601</ZIP>
	</ADDRESS>
	<TELEPHONE>
	<AREACODE>305</AREACODE>
	<PHONE>987 6543</PHONE>
	</TELEPHONE>
</CUSTOMER>');

-- Fig 13.20(c)

select object_value from customers2;

-- Fig 13.20(d)

select value(c) from customers2 c;

-- Fig 13.20(e)

select extract(object_value,'/CUSTOMER/NAME') from customers2;


-- Fig 13.20(f)

select extractValue(object_value, '/CUSTOMER/NAME'), extractValue(object_value, '/CUSTOMER/ADDRESS/CITY') 
from customers2;
 
-- Fig 13.29(g)

select extractValue(object_value, '/CUSTOMER/NAME')
from customers2
where extractValue(object_value, '/CUSTOMER/ADDRESS/CITY')= 'Miami';









	